Recycle bin is actually a data dictionary table containing information about dropped objects. Dropped tables and any associated objects such as indexes, constraints, nested tables, and the likes are not removed and still occupy space. They continue to count against user space quotas, until specifically purged from the recycle bin or the unlikely situation where they must be purged by the database because of tablespace space constraints.
Just simply click ->
Recycle Bin to
open an object pane for Recycle Bin. A control-click displays
the popup menu or using the object pane toolbar below, allowing you to flashback tables or purge the deleted objects.
Restore Tables
To restore a table from recycle bin
- Choose a table in recycle bin.
- Click the Flashback from the object
pane toolbar.
or - Control-click and select Flashback Table from the popup menu.
Purge Objects
To remove an object in the recycle bin
- Select an object for purging in the object pane.
- Control-click and select the Purge Object
from the popup menu.
or - Click the Purge from the object pane toolbar.
- Confirm deleting in the dialog window.
To remove all objects in the recycle bin
- Control-click and select the Purge Recycle Bin from the popup menu.
- Confirm deleting in the dialog window.
To remove all objects in the recycle bin of every user
- Log in a user has the SYSDBA privilege.
- Control-click and select the Purge DBA Recycle Bin from the popup menu.
- Confirm deleting in the dialog window.
Achieve Recycle Bin Information
To achieve an object information in recycle bin
- Select the object in the object pane.
- Choose View -> Object Information in the main menu to view the Object Information.
or - Click the
from the object pane toolbar.